Use this query to create Jobs based upon a single Job: Insert Into [Job] ([DBId], [Id], [Number], [ClientId], [JobTypeId], [DivisionId], [Description], [Actif], [Archive], [JobServiceTRRestriction], [StartDate], [EndDate], [Chargeable], [Status], [TRLockType], [FileHolderEmployeeId], [ReferenceYear], [SupplierBudgetAmount], [JobCategoryId], [StrategyId]) Select [Client].[DBId] as [ResDBId], ROW_NUMBER() OVER(ORDER BY left(case when [Company].[Name] Is Null then [Person].[Name] else [Company].[Name] end,63)) + nnnn AS [ResId], … Continue reading Query to create Jobs based upon Job